Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Răspunsuri (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

Trebuie să vă conectaţi pentru a publica în discuţii.

Vizualizaţi termeni similari

Ibotta
Software; Aplicaţii telefon

Ibotta allows shoppers to earn real money for shopping. ...

USB
Software; Sisteme de operare

type of port for connecting computer devices such as a ...

YourShow
Software; Software productivitate

A presentation software that empowers you to deliver more ...

Nike+ Running App
Software; Aplicaţii telefon

This app will help you to track your runs and reach new ...

defragmentation
Software; Software engineering

In the maintenance of file systems, defragmentation is a ...

iOS
Software; Sisteme de operare

Apple iOS is a mobile operating system developed and ...

Creator

Glosare dezvoltate

Food poisoning

Categorie: Health   2 6 Terms

Oil Painting

Categorie: Arte   1 22 Terms

Labud Zagreb

Categorie: Business   1 23 Terms

The Top 25 Must-See Movies Of 2014

Categorie: Divertisment   1 25 Terms

Artisan Bread

Categorie: Food   2 30 Terms

Top 10 University in Beijing, China

Categorie: Educaţie   1 10 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Urmaţi-ne pe: